Description: The American Academy of Actuaries and the Society of Actuaries have joined resources to maintain this Economic Scenario Generators Excel Workbook tool for use in regulatory reserve and capital calculations. Please see the SOA website research pages for further information on this tool and how to use it.

Description: This is an Excel workbook, provided by the Society of Actuaries Pension Section, containing consumer price index data obtained from the U.S. Department of Labor Bureau of Labor Statistics. Separate tabs include figures for the CPI-U, the Medical Care Consumer Price Index, etc.

Description: The American Academy of Actuaries and the Society of Actuaries have joined resources to maintain this Economic Scenario Generators Excel Workbook tool for use in regulatory reserve and capital calculations. Please see the SOA website research pages for further information on this tool and how to use it.

Description: The Revenue Act of 1987 amended section 807d2B of the Internal Revenue Code. It established the interest rate used in the calculation of tax reserves to be the greater of the applicable federal interest rate or the prevailing maximum statutory valuation rate for the contract’s calendar year of issue. The amendment is effective for contracts issued in tax years beginning after December 31, 1987. This document shows all the applicable federal interest rates from 1998 - 2009.

Description: The Society of Actuaries' Pension Section and Health Section Research teams commissioned Professor Thomas E. Getzen of Temple University to construct a resource model for the projection of long term healthcare cost trends. The motivation for creation of the model was driven by its potential usage as a resource for the estimation of reportable liabilities for retiree healthcare benefits as specified under FAS 106 and GASB 45 accounting statements. This model, programmed in Microsoft Excel [xlsx format], projects per-person expenditures and growth rates through 2099 using a set of equations and assumptions developed by Professor Getzen with assistance from the Society of Actuaries Project Oversight Group appointed to oversee the effort. The model includes baseline assumptions as well as flexibility for user–inputted alternative assumptions.

Description: The Required Minimum Distribution RMD working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This is Appendix G spreadsheet for the Determining the Actuarial Present Value of Certain Additional Benefits for a two tiered fixed annuity benefit Under Treas. Reg. Section 1.401a9–6, Q&A–12 research project. Please see the SOA website research section for the full report and other appendices spreadsheets.

Description: The Required Minimum Distribution RMD working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferrred annuity contracts. This is Appendix B Example 2 spreadsheet for GMDB for this research project. Please see the SOA website research section for the full report and excel spreadsheet for the other appendices.

Description: The Required Minimum Distribution [RMD] working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This is Appendix H spreadsheet for persistency bonus calculations for this research project. Please see teh SOA website research section for the complete report and excel spreadsheets for other appendices.

Description: The Required Minimum Distribution [RMD] working group of the Taxation Section has completed research in determing the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This Appendix E spreadsheet is for the Guaranteed Minimum Withdrawal Benefit [GMWB] calculation. See the SOA website research section for the complete report and excel spreadsheet for the other appendices.

Description: The Required Minimum Distribution [RMD] Working Group of the SOA Taxation Section has completed research identifying considerations for actuaries and annuity insurers in determing the actuarial present value of additional benefits for computing the RMD under a deferred annuity contract. This is the Appendix I spreadsheet for determining the Actuarial Present Value of an annuitization bonus. Please see the SOA website research for the full report and other associated spreadsheets.